<?xml version="1.0"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema">
  <xs:complexType name="Purchase_Orders">
    <xs:sequence>
      <xs:element name="Supplier_ID_Row" type="Suppliers" />
      <xs:element name="Created_By_Row" type="Employees" />
      <xs:element name="Purchase_Order_Details_Rows">
        <xs:complexType>
          <xs:sequence>
            <xs:element name="Purchase_Order_Details_Row" type="Purchase_Order_Details" />
          </xs:sequence>
        </xs:complexType>
      </xs:element>
    </xs:sequence>
    <xs:attribute name="Purchase_Order_ID" type="xs:integer" />
    <xs:attribute name="Supplier_ID" type="xs:integer" />
    <xs:attribute name="Created_By" type="xs:integer" />
    <xs:attribute name="Submitted_Date" type="xs:dateTime" />
    <xs:attribute name="Creation_Date" type="xs:dateTime" />
    <xs:attribute name="Status_ID" type="xs:integer" />
    <xs:attribute name="Expected_Date" type="xs:dateTime" />
    <xs:attribute name="Shipping_Fee" type="xs:decimal" />
    <xs:attribute name="Taxes" type="xs:decimal" />
    <xs:attribute name="Payment_Date" type="xs:dateTime" />
    <xs:attribute name="Payment_Amount" type="xs:decimal" />
    <xs:attribute name="Payment_Method" type="xs:string" />
    <xs:attribute name="Notes" type="xs:string" />
    <xs:attribute name="Approved_By" type="xs:integer" />
    <xs:attribute name="Approved_Date" type="xs:dateTime" />
    <xs:attribute name="Submitted_By" type="xs:integer" />
  </xs:complexType>
  <xs:complexType name="Suppliers">
    <xs:sequence />
    <xs:attribute name="ID" type="xs:integer" />
    <xs:attribute name="Company" type="xs:string" />
    <xs:attribute name="Last_Name" type="xs:string" />
    <xs:attribute name="First_Name" type="xs:string" />
    <xs:attribute name="E-mail_Address" type="xs:string" />
    <xs:attribute name="Job_Title" type="xs:string" />
    <xs:attribute name="Business_Phone" type="xs:string" />
    <xs:attribute name="Home_Phone" type="xs:string" />
    <xs:attribute name="Mobile_Phone" type="xs:string" />
    <xs:attribute name="Fax_Number" type="xs:string" />
    <xs:attribute name="Address" type="xs:string" />
    <xs:attribute name="City" type="xs:string" />
    <xs:attribute name="State_Province" type="xs:string" />
    <xs:attribute name="ZIP_Postal_Code" type="xs:string" />
    <xs:attribute name="Country_Region" type="xs:string" />
    <xs:attribute name="Web_Page" type="xs:string" />
    <xs:attribute name="Notes" type="xs:string" />
    <xs:attribute name="Attachments" type="xs:string" />
  </xs:complexType>
  <xs:complexType name="Employees">
    <xs:sequence />
    <xs:attribute name="ID" type="xs:integer" />
    <xs:attribute name="Company" type="xs:string" />
    <xs:attribute name="Last_Name" type="xs:string" />
    <xs:attribute name="First_Name" type="xs:string" />
    <xs:attribute name="E-mail_Address" type="xs:string" />
    <xs:attribute name="Job_Title" type="xs:string" />
    <xs:attribute name="Business_Phone" type="xs:string" />
    <xs:attribute name="Home_Phone" type="xs:string" />
    <xs:attribute name="Mobile_Phone" type="xs:string" />
    <xs:attribute name="Fax_Number" type="xs:string" />
    <xs:attribute name="Address" type="xs:string" />
    <xs:attribute name="City" type="xs:string" />
    <xs:attribute name="State_Province" type="xs:string" />
    <xs:attribute name="ZIP_Postal_Code" type="xs:string" />
    <xs:attribute name="Country_Region" type="xs:string" />
    <xs:attribute name="Web_Page" type="xs:string" />
    <xs:attribute name="Notes" type="xs:string" />
    <xs:attribute name="Attachments" type="xs:string" />
  </xs:complexType>
  <xs:complexType name="Purchase_Order_Details">
    <xs:sequence>
      <xs:element name="Product_ID_Row" type="Products" />
    </xs:sequence>
    <xs:attribute name="ID" type="xs:integer" />
    <xs:attribute name="Purchase_Order_ID" type="xs:integer" />
    <xs:attribute name="Product_ID" type="xs:integer" />
    <xs:attribute name="Quantity" type="xs:decimal" />
    <xs:attribute name="Unit_Cost" type="xs:decimal" />
    <xs:attribute name="Date_Received" type="xs:dateTime" />
    <xs:attribute name="Posted_To_Inventory" type="xs:boolean" />
    <xs:attribute name="Inventory_ID" type="xs:integer" />
  </xs:complexType>
  <xs:complexType name="Products">
    <xs:sequence />
    <xs:attribute name="Supplier_IDs" type="xs:string" />
    <xs:attribute name="ID" type="xs:integer" />
    <xs:attribute name="Product_Code" type="xs:string" />
    <xs:attribute name="Product_Name" type="xs:string" />
    <xs:attribute name="Description" type="xs:string" />
    <xs:attribute name="Standard_Cost" type="xs:decimal" />
    <xs:attribute name="List_Price" type="xs:decimal" />
    <xs:attribute name="Reorder_Level" type="xs:short" />
    <xs:attribute name="Target_Level" type="xs:integer" />
    <xs:attribute name="Quantity_Per_Unit" type="xs:string" />
    <xs:attribute name="Discontinued" type="xs:boolean" />
    <xs:attribute name="Minimum_Reorder_Quantity" type="xs:short" />
    <xs:attribute name="Category" type="xs:string" />
    <xs:attribute name="Attachments" type="xs:string" />
  </xs:complexType>
  <xs:element name="Purchase_Orders_Rows">
    <xs:complexType>
      <xs:sequence>
        <xs:element name="Purchase_Orders_Row" type="Purchase_Orders" />
      </xs:sequence>
    </xs:complexType>
  </xs:element>
</xs:schema>